package com.xpgk.mvc.dept;

import com.jfinal.log.Log;
import com.xpgk.annotation.Table;
import com.xpgk.mvc.base.BaseModel;

/**
 * 部门model
 */
@SuppressWarnings("unused")
@Table(tableName = Department.table_name)
public class Department extends BaseModel<Department> {

	private static final long serialVersionUID = 6761767368352810428L;

	private static final Log log = Log.getLog(Department.class);

	public static final Department dao = new Department().dao();

	/**
	 * 表名称
	 */
	public static final String table_name = "sys_department";

	/**
	 * 字段描述：该条数据添加人员is  字段类型：character varying 长度：32
	 */
	public static final String column_createId = "createId";
	/**
	 * 字段描述：该条数据添加时间  字段类型：datetime 长度：0
	 */
	public static final String column_createDate = "createDate";
	/**
	 * 字段描述：该条数据更新人员id  字段类型：character varying 长度：100
	 */
	public static final String column_updateId = "updateId";
	/**
	 * 字段描述：该条数据更新时间  字段类型：datetime 长度：0
	 */
	public static final String column_updateDate = "updateDate";
	
	/**
	 * 字段描述：主键 字段类型：character varying 长度：32
	 */
	public static final String column_ids = "ids";

	/**
	 * 字段描述：bh
	 */
	public static final String column_bh = "bh";

	/**
	 * 字段描述：部门级别 字段类型：bigint 长度：null
	 */
	public static final String column_level = "levelnum";

	/**
	 * 字段描述：状态
	 */
	public static final String column_status = "status";

	/**
	 * 字段描述：是否上级节点 字段类型：character varying 长度：5
	 */
	public static final String column_isparent = "isparent";

	/**
	 * 字段描述：名称 字段类型：character varying 长度：25
	 */
	public static final String column_name = "name";

	/**
	 * 字段描述：排序号 字段类型：bigint 长度：null
	 */
	public static final String column_orderid = "orderid";

	/**
	 * 字段描述：上级ids 字段类型 ：character varying
	 */
	public static final String column_parentids = "parentids";

	/**
	 * 字段描述：icon
	 */
	public static final String column_icon = "icon";

	/**
	 * 字段描述：所属机构ids 字段类型 ：character varying
	 */
	public static final String column_organizationids = "organizationids";

	/**
	 * sqlId : 描述：查询指定机构的部门根节点
	 */
	public static final String sqlId_findRootByOrgan = "sys.department.findRootByOrgan";

	/**
	 * sqlId : 描述：指定机构下所有部门
	 */
	public static final String sqlId_allDeptByOrgan = "sys.department.allDeptByOrgan";
	
	/**
	 * sqlId : 描述：指定机构下根部门
	 */
	public static final String sqlId_rootDeptByOrgan = "sys.department.rootDeptByOrgan";

	/**
	 * sqlId : sys.department.noChecked 描述：查询根节点
	 */
	public static final String sqlId_rootNode = "sys.department.rootNode";

	/**
	 * sqlId : sys.department.childNode 描述：根据上级节点id查询子部门信息
	 */
	public static final String sqlId_childNode = "sys.department.childNode";

	/**
	 * sqlId : sys.department.childCount 描述：根据上级节点id查询子节点数量
	 */
	public static final String sqlId_childCount = "sys.department.childCount";

	/**
	 * sqlId : sys.department.userCount 描述：查询部门下人员数量
	 */
	public static final String sqlId_userCount = "sys.department.userCount";

	/**
	 * sqlId : sys.department.childrenList 描述：查询子集部门列表
	 */
	public static final String sqlId_childrenList = "sys.department.childrenList";

	/**
	 * sqlId : sys.department.splitPageSelect 描述：分页Select
	 */
	public static final String sqlId_splitPageSelect = "sys.department.splitPageSelect";

	/**
	 * sqlId : sys.department.splitPageFrom 描述：分页from
	 */
	public static final String sqlId_splitPageFrom = "sys.department.splitPageFrom";
 

}
